<?php

class Renew_Model_TenpoNinki extends Apm_Model_Base
{

    public function getTenpoNinkiArea()
    {
        $sql = "SELECT M05_TENPO_TODOUFUKEN_CD,  M05_TENPO_SHIKUCHOUSON_CD, M05_TENPO_SHIKUCHOUSON
                FROM (
                 SELECT M05_TENPO_TODOUFUKEN_CD, M05_TENPO_SHIKUCHOUSON_CD, M05_TENPO_SHIKUCHOUSON
                 FROM M05TENPO_INFO SAMPLE(20)
                 ORDER BY DBMS_RANDOM.RANDOM
                 )
                WHERE ROWNUM<=20
            ";
        $list = $this->dbGetList($sql);

        return $list;
    }

}
?>